This query extracts customers who have purchased more than $100 within a specific date range.
1. Browse to IQA.
2. Select Query from the drop-down list and select New.
3. Select sources:
□ Browse to the Common folder containing business objects.
□ Select the CsContact and CsActivityBasic business objects.
□ Make sure the default join in the Relations area is Contact.iMIS Id Equals CsActivityBasic.Id.
4. Define the filtering rules:
□ Select the Filters tab.
□ Mode: Basic
□ Filter on CsActivityBasic.Activity Type.
■ Property: CsActivityBasic.Activity Type
■ Comparison: Equals
■ Value: ORDER
■ Click the + icon to add the filter.
□ Filter on CsActivityBasic.Transaction Date.
■ Property: CsActivityBasic.Transaction Date
■ Comparison: Between
■ Value: "1/1/2011","12/31/2011"
■ Click the + icon to add the filter.
□ Filter on CsActivityBasic.Amount.
■ Property: CsActivityBasic.Amount
■ Comparison: Greater
■ Value: 100
■ Click the + icon to add the filter.
5. Define the columns to display in the output:
□ Select the Display tab.
□ Select the following columns:
■ CsContact.iMIS Id
■ CsActivityBasic.Amount
Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.
□ Using the Order drop-down list on the Display tab, assign:
■ CsContact.iMIS Id Order 1
■ CsActivityBasic.Amount Order 2
6. Specify the sorting priority:
□ Select the Sorting tab.
□ Sort the results by CsContact.iMIS Id.
□ Click the + icon to add the selection.
7. Save your settings.
8. Run the query.